Community

SQL question

I am using MySQL on a Flask App after following the Flask tutorial. My app will send automated text messages to customers from users. So far I have a table named users. It has rows (uid, username, password, email, settings, rank). I want each user to be able to pull up a list of all the customers they have sent messages too. I would like the customer table to have at least these columns  (name, city, phone number, status). My confusion is, do I need to make a new customer table for each user or can I use one database that has every user's customers information and access only the specific user's customer base somehow.